﻿/*CREATE VIEW dbo.vwParliamentarianLinks
AS
SELECT     MPs.CPALId, MPs.MPID, MPs.Title, MPs.FirstName, MPs.Surname, Links.PartyWebsite, Links.PersonalWebsite, Links.FacebookAddress, Links.TwitterAddress
FROM         dbo.ParliamentarianWebLinks AS Links RIGHT OUTER JOIN
                      dbo.Parliamentarians AS MPs ON Links.CPALId = MPs.CPALId
WHERE     (MPs.FormerMember = 0)*/